To Configure Task Processing

In the Data Processing database, alter tables [SystemComponentPartExtendedVPM] and [SystemComponentPartVPM] by adding new columns: [ST_EXT_WEIGHT_RANGE] and [ST_EXT_TYPE].

Using code

alter table [databasename] . [dbo] . [SystemComponentPartExtendedVPM]

add ST_EXT_WEIGHT_RANGE varchar (255), ST_EXT_TYPE varchar (255);

alter table [databasename] . [dbo] . [SystemComponentPartVPM]

add ST_EXT_WEIGHT_RANGE varchar (255), ST_EXT_TYPE varchar (255);

Run the C:\Program Files (x86)\Bentley\ConstructSim V8i\ConstructSim\CSimDPConfiguration.exe file. The VCM Data Processing Configuration dialog opens.
Enter the Server Name and Database Name.
Click the Work Details Settings button. The Import Work Details dialog opens.
Set the Adapter Type to SPURT Adapter.
Click Configure.
For SPURT MDB Filepath, browse and select the project …\ProjectData\UnitRates\SPURT_<ProjectName>.mdb.
Set the Adapter Type to Steel Unit Rate Adapter.
Click Configure.
For Steel Unit Rate Database Filepath, browse and select the project …\ProjectData\UnitRates\ SSURT_<ProjectName>.mdb.
Click OK.